<html>
	<head>
		<link rel='stylesheet' type='text/css' href='style.css'>
		<title>xSheets - Help</title>
	</head>
	<body>
		<a href='https://jason-bowen-zheng.github.io/xSheets/index.html'>Home</a>|
		Help|
		<a href='https://jason-bowen-zheng.github.io/xSheets/howto.html'>HOWTO</a>
		<hr>
		<h1>Help for xSheets</h1>
		<h2>Function</h2>
		All function definitions are in "Formula"-&gt;"Insert function..."
		<h3>Logical Function</h3>
		<table border='1'>
			<tr>
				<th>Functions</th>
				<th>Useage</th>
				<th>Detail</th>
			</tr>
			<tr>
				<td>all</td>
				<td>all(seq)</td>
				<td>
					return True if all value in seq is not None.
				</td>
			</tr>
			<tr>
				<td>any</td>
				<td>any(seq)</td>
				<td>
					return True if all value in seq is not None.
				</td>
			</tr>
			<tr>
				<td>bin</td>
				<td>bin(n)</td>
				<td>
					return the binary representation of n.
				</td>
			</tr>
			<tr>
				<td>choose</td>
				<td>choose(con, a, b)</td>
				<td>
					if con is True:<br>
					&nbsp; &nbsp; return a<br>
					else:<br>
					&nbsp; &nbsp; return b
				</td>
			</tr>
			<tr>
				<td>chooses</td>
				<td>choose(n, l)</td>
				<td>
					if n &lt; 0 or n &gt; length of l:<br>
					&nbsp; &nbsp; return l[0] or l[-1]<br>
					else:<br>
					&nbsp; &nbsp; return l[int(n)]
				</td>
			</tr>
			<tr>
				<td>count</td>
				<td>count(seq)</td>
				<td>
					return the number of not null cells in seq.
				</td>
			</tr>
			<tr>
				<td>false</td>
				<td>false()</td>
				<td>
					return boolean false.
				</td>
			</tr>
			<tr>
				<td>hex</td>
				<td>hex(n)</td>
				<td>
					return the hexadecimal representation of n.
				</td>
			</tr>
			<tr>
				<td>oct</td>
				<td>oct(n)</td>
				<td>
					return the octal representation of n.
				</td>
			</tr>
			<tr>
				<td>roman2int</td>
				<td>roman2int(roman)</td>
				<td>
					covered roman number to integer.
				</td>
			<tr>
				<td>true</td>
				<td>true()</td>
				<td>
					return boolean true.
				</td>
			</tr>
		</table>
		<h3>Math function</h3>
		<table border='1'>
			<tr>
				<th>Function</th>
				<th>Usage</th>
				<th>Detail</th>
			</tr>
			<tr>
				<td>abs</td>
				<td>abs(x)</td>
				<td>
					return the absolute value of x.
				</td>
			</tr>
			<tr>
				<td>cos</td>
				<td>cos(x)</td>
				<td>
					return the cos of x.
				</td>
			</tr>
			<tr>
				<td>max</td>
				<td>max(seq)</td>
				<td>
					return the maximum number in seq.
				</td>
			</tr>
			<tr>
				<td>min</td>
				<td>min(seq)</td>
				<td>
					return the minimum number in seq.
				</td>
			</tr>
			<tr>
				<td>pi</td>
				<td>pi()</td>
				<td>
					return PI.
				</td>
			</tr>
			<tr>
				<td>round</td>
				<td>round(x, n=None)</td>
				<td>
					round a number to a given precision in decimal digits.
				</td>
			</tr>
			<tr>
				<td>sin</td>
				<td>sin(x)</td>
				<td>
					return the sin of x.
				</td>
			</tr>
			<tr>
				<td>tan</td>
				<td>tan(x)</td>
				<td>
					return the tan of x.
				</td>
			</tr>
			<tr>
				<td>tau</td>
				<td>tau()</td>
				<td>
					return TAU.
				</td>
			</tr>
		</table>
		<h3>Statistical Function</h3>
		<table border='1'>
			<tr>
				<th>Function</th>
				<th>Usage</th>
				<th>Detail</th>
			</tr>
			<tr>
				<td>average</td>
				<td>average(seq)</td>
				<td>
					return average number of seq.
				</td>
			</tr>
			<tr>
				<td>geometric_mean</td>
				<td>geometric_mean(seq)</td>
				<td>
					return geometric mean of seq.
				</td>
			</tr>
			<tr>
				<td>harmonic_mean</td>
				<td>harmonic_mean(seq)</td>
				<td>
					return harmonic mean of seq.
				</td>
			</tr>
			<tr>
				<td>median</td>
				<td>median(seq)</td>
				<td>
					return median of seq.
				</td>
			</tr>
			<tr>
				<td>sum</td>
				<td>sum(seq)</td>
				<td>
					return sum of seq.
				</td>
			</tr>
		</table>
		<hr>
		<p class='footer'>
			Copyright &copy; jason-bowen-zheng 2020<br>
			All Right Reserved.
		</p>
	</body>
</html>
